{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Einleitung","Start","Chefinfo","Angebote","Aufträge","Einrichtung","Anleitung","Intern"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":0,"defined_names":16,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Einleitung","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Start","index":1,"n_rows":65,"n_cols":27,"rows_kept":65,"cut":false,"hidden":false,"merged":[[26,11,27,12],[23,15,24,15],[15,4,15,5],[21,4,23,6],[21,11,24,12],[23,16,24,17],[19,15,21,15],[19,16,21,17],[13,7,13,14],[12,7,12,14],[14,6,14,15],[16,4,16,6]]}
[]
[null,null,"Auftragsplanung | Software"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Intern!A4","v":"Version 1.20"},null,null,null,null,null,null,null,null,{"$f":" \"Firma:  \" &Start!Q20","v":"Firma:  Mustermann GmbH"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Auftragsplanung - Hauptmenü"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"EDATE($W$17,-6)","v":"2016-02-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"EDATE($W$17,-5)","v":"2016-03-01"}]
[null,null,null,null,null,null,null,"Diese Software ist personalisiert für ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"EDATE($W$17,-4)","v":"2016-04-01"}]
[null,null,null,null,null,null,null,"Max Muster",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"EDATE($W$17,-3)","v":"2016-05-01"}]
[null,null,null,null,null,null,"Mustermann GmbH | An der Burgermühle 10 | 83022 Rosenheim",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"EDATE($W$17,-2)","v":"2016-06-01"}]
[null,null,null,"Erfassungsdatum:",{"$f":"IF(R27=\"\",\"\",R27)","v":"2016-05-10"},null,null,null,null,"für Monat:",{"$f":"R28","v":42461},null,null,null,null,null,null,null,null,null,{"$f":"YEAR(R27)","v":2016},null,{"$f":"EDATE($W$17,-1)","v":"2016-07-01"}]
[null,null,null,"erfasst von:",{"$f":"IF(R29=\"\",\"\",R29)","v":"Max Muster"},null,null,null,null,"Die Einrichtung erfolgt nach Vorgabe der Firma",null,null,null,null,null,null,null,null,null,null,{"$f":"DATE($U$16,1,1)","v":"2016-01-01"},null,{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),1)","v":"2016-08-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE($U$16,2,1)","v":"2016-02-01"},null,{"$f":"EDATE($W$17,1)","v":"2016-09-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE($U$16,3,1)","v":"2016-03-01"},null,{"$f":"EDATE($W$17,2)","v":"2016-10-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Firma:","Mustermann GmbH",null,null,null,{"$f":"DATE($U$16,4,1)","v":"2016-04-01"},null,{"$f":"EDATE($W$17,3)","v":"2016-11-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE($U$16,5,1)","v":"2016-05-01"},null,{"$f":"EDATE($W$17,4)","v":"2016-12-01"}]
[null,null,null,null,"Anleitung",null,null,null,null,null,null,"Auftragsplanung \nAngebote",null,null,null,null,null,null,null,null,{"$f":"DATE($U$16,6,1)","v":"2016-06-01"},null,{"$f":"EDATE($W$17,5)","v":"2017-01-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE($U$16,7,1)","v":"2016-07-01"},null,{"$f":"EDATE($W$17,6)","v":"2017-02-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Berater:","Roland Bauer",null,null,null,{"$f":"DATE($U$16,8,1)","v":"2016-08-01"},null,{"$f":"EDATE($W$17,7)","v":"2017-03-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE($U$16,9,1)","v":"2016-09-01"},null,{"$f":"EDATE($W$17,8)","v":"2017-04-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE($U$16,10,1)","v":"2016-10-01"},null,{"$f":"EDATE($W$17,9)","v":"2017-05-01"}]
[null,null,null,null,"Einrichtung",null,null,null,null,null,null,"Auftragsplanung\nAufträge",null,null,null,"Erfassungsdatum:",null,"2016-05-10",null,{"$f":"TEXT(R27,\"MM\")","v":"05"},{"$f":"DATE($U$16,11,1)","v":"2016-11-01"},null,{"$f":"EDATE($W$17,10)","v":"2017-06-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"für Monat:",null,"2016-04-01",null,{"$f":"TEXT(R28,\"MM\")","v":"04"},{"$f":"DATE($U$16,12,1)","v":"2016-12-01"},null,{"$f":"EDATE($W$17,11)","v":"2017-07-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"erfasst von:",null,"Max Muster",null,null,null,null,{"$f":"EDATE($W$17,12)","v":"2017-08-01"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"© bauerundpartner"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Erfassungsdatum:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"für Monat:",{"$f":"IF(Start!R28=\"\",\"\",Start!R28)","v":42461}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"erfasst von:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roland Bauer"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hartmut Weigelt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Angelika Holzner"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bp"]

{"sheet":"Chefinfo","index":2,"n_rows":37,"n_cols":61,"rows_kept":37,"cut":false,"hidden":true,"merged":[[9,2,9,9],[25,2,25,9]]}
[]
[null,null,"Auftragsplanung | Chefinfo",null,null,null,null,"2016-02-04",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2016-08-09"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"YEAR($BG$2)-1","v":2015}]
[null,null,{"$f":"Start!AA4&\"      \"&\"Erfassungsdatum: \"&TEXT(Start!E16,\"TT.MM.JJJJ\")&\"     \"&\"für Monat: \"&TEXT(Start!AA46,\"MM/JJJJ\")&\"       \"&\"erfasst von: \"&TEXT(Start!E17,\"\")","v":"Firma:  Mustermann GmbH      Erfassungsdatum: 10.05.2016     für Monat: 04/2016       erfasst von: Max Muster"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"YEAR($BG$2)-1","v":2015},null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"YEAR($BG$2)","v":2016},null,{"$f":"VLOOKUP(BI4,BF3:BG7,2)","v":2016}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"YEAR($BG$2)+1","v":2017}]
[null,null,null,{"$f":"BI5","v":2016},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"YEAR($BG$2)+2","v":2018}]
[]
[null,null,null,{"$f":"DATE($D$7,1,1)","v":"2016-01-01"},{"$f":"DATE($D$7,2,1)","v":"2016-02-01"},{"$f":"DATE($D$7,3,1)","v":"2016-03-01"},{"$f":"DATE($D$7,4,1)","v":"2016-04-01"},{"$f":"DATE($D$7,5,1)","v":"2016-05-01"},{"$f":"DATE($D$7,6,1)","v":"2016-06-01"},{"$f":"DATE($D$7,7,1)","v":"2016-07-01"},{"$f":"DATE($D$7,8,1)","v":"2016-08-01"},{"$f":"DATE($D$7,9,1)","v":"2016-09-01"},{"$f":"DATE($D$7,10,1)","v":"2016-10-01"},{"$f":"DATE($D$7,11,1)","v":"2016-11-01"},{"$f":"DATE($D$7,12,1)","v":"2016-12-01"}]
[null,null,"Chefinfo Angebotsübersicht",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jahr",null,null,null,null,null,null,null,"Grenzwerte",null,null,"Handlungsanweisungen"]
[null,null,null,{"$f":"MONTH(D9)","v":1},{"$f":"MONTH(E9)","v":2},3,4,5,6,7,8,9,10,11,12]
[null,null,null,"Jan","Feb","Mrz","Apr","Mai","Jun","Jul","Aug","Sept","Okt","Nov","Dez",null,"jan",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kum.",null,null,null,null,null,null,null,">= grün",">= gelb","rot",1,2,3]
[null,null,"Auftragswert in T€",{"$f":"IF(Q14=0,\"\",Q13)","v":""},{"$f":"IF(R14=0,\"\",R13)","v":480},"","","","","","","","","","",null,{"$f":"IF(D14>0,SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,D$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,D$11,31))*(OR(Angebote!$P$14:$P$24=1,Angebote!$P$14:$P$24=2))*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$Q$14:$Q$24),\"\")","v":0},{"$f":"IF(E14>0,SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,E$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,E$11,31))*(OR(Angebote!$P$14:$P$24=1,Angebote!$P$14:$P$24=2))*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$Q$14:$Q$24),\"\")","v":480},{"$f":"IF(F14>0,SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,F$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,F$11,31))*(OR(Angebote!$P$14:$P$24=1,Angebote!$P$14:$P$24=2))*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$Q$14:$Q$24),\"\")","v":0},{"$f":"IF(G14>0,SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,G$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,G$11,31))*(OR(Angebote!$P$14:$P$24=1,Angebote!$P$14:$P$24=2))*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$Q$14:$Q$24),\"\")","v":0},{"$f":"IF(H14>0,SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,H$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,H$11,31))*(OR(Angebote!$P$14:$P$24=1,Angebote!$P$14:$P$24=2))*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$Q$14:$Q$24),\"\")","v":0},{"$f":"IF(I14>0,SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,I$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,I$11,31))*(OR(Angebote!$P$14:$P$24=1,Angebote!$P$14:$P$24=2))*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$Q$14:$Q$24),\"\")","v":0},{"$f":"IF(J14>0,SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,J$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,J$11,31))*(OR(Angebote!$P$14:$P$24=1,Angebote!$P$14:$P$24=2))*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$Q$14:$Q$24),\"\")","v":0},{"$f":"IF(K14>0,SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,K$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,K$11,31))*(OR(Angebote!$P$14:$P$24=1,Angebote!$P$14:$P$24=2))*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$Q$14:$Q$24),\"\")","v":0},{"$f":"IF(L14>0,SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,L$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,L$11,31))*(OR(Angebote!$P$14:$P$24=1,Angebote!$P$14:$P$24=2))*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$Q$14:$Q$24),\"\")","v":0},{"$f":"IF(M14>0,SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,M$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,M$11,31))*(OR(Angebote!$P$14:$P$24=1,Angebote!$P$14:$P$24=2))*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$Q$14:$Q$24),\"\")","v":0},{"$f":"IF(N14>0,SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,N$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,N$11,31))*(OR(Angebote!$P$14:$P$24=1,Angebote!$P$14:$P$24=2))*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$Q$14:$Q$24),\"\")","v":0},{"$f":"IF(O14>0,SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,O$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,O$11,31))*(OR(Angebote!$P$14:$P$24=1,Angebote!$P$14:$P$24=2))*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$Q$14:$Q$24),\"\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q13+R13+S13+T13+U13+V13+W13+X13+Y13+Z13+AA13+AB13","v":480},null,null,{"$f":"IF(AQ13>=AY13,1,IF(AQ13>=AZ13,2,3))","v":3},{"$f":"AQ13","v":480},null,{"$f":"HLOOKUP(AT13,$BB$12:$BD$22,2)","v":"Handlungsanweisung für rot"},null,2000,500,null,"Handlungsanweisung für grün","Handlungsanweisung für gelb","Handlungsanweisung für rot"]
[null,null,"Anzahl erhaltene Aufträge",{"$f":"IF(Q14=0,\"\",Q14)","v":""},{"$f":"IF(R14=0,\"\",R14)","v":2},"","","","","","","","","","",null,{"$f":"(SUMPRODUCT((Angebote!$B$14:$B$23>=DATE($D$7,D$11,1))*(Angebote!$B$14:$B$23<=DATE($D$7,D$11,31))*(Angebote!$P$14:$P$23=1)*(Angebote!$B$14:$B$23<>\"#NV\")))+(SUMPRODUCT((Angebote!$B$14:$B$23>=DATE($D$7,D$11,1))*(Angebote!$B$14:$B$23<=DATE($D$7,D$11,31))*(Angebote!$P$14:$P$23=2)*(Angebote!$B$14:$B$23<>\"#NV\")))","v":0},{"$f":"(SUMPRODUCT((Angebote!$B$14:$B$23>=DATE($D$7,E$11,1))*(Angebote!$B$14:$B$23<=DATE($D$7,E$11,31))*(Angebote!$P$14:$P$23=1)*(Angebote!$B$14:$B$23<>\"#NV\")))+(SUMPRODUCT((Angebote!$B$14:$B$23>=DATE($D$7,E$11,1))*(Angebote!$B$14:$B$23<=DATE($D$7,E$11,31))*(Angebote!$P$14:$P$23=2)*(Angebote!$B$14:$B$23<>\"#NV\")))","v":2},{"$f":"(SUMPRODUCT((Angebote!$B$14:$B$23>=DATE($D$7,F$11,1))*(Angebote!$B$14:$B$23<=DATE($D$7,F$11,31))*(Angebote!$P$14:$P$23=1)*(Angebote!$B$14:$B$23<>\"#NV\")))+(SUMPRODUCT((Angebote!$B$14:$B$23>=DATE($D$7,F$11,1))*(Angebote!$B$14:$B$23<=DATE($D$7,F$11,31))*(Angebote!$P$14:$P$23=2)*(Angebote!$B$14:$B$23<>\"#NV\")))","v":0},{"$f":"(SUMPRODUCT((Angebote!$B$14:$B$23>=DATE($D$7,G$11,1))*(Angebote!$B$14:$B$23<=DATE($D$7,G$11,31))*(Angebote!$P$14:$P$23=1)*(Angebote!$B$14:$B$23<>\"#NV\")))+(SUMPRODUCT((Angebote!$B$14:$B$23>=DATE($D$7,G$11,1))*(Angebote!$B$14:$B$23<=DATE($D$7,G$11,31))*(Angebote!$P$14:$P$23=2)*(Angebote!$B$14:$B$23<>\"#NV\")))","v":0},{"$f":"(SUMPRODUCT((Angebote!$B$14:$B$23>=DATE($D$7,H$11,1))*(Angebote!$B$14:$B$23<=DATE($D$7,H$11,31))*(Angebote!$P$14:$P$23=1)*(Angebote!$B$14:$B$23<>\"#NV\")))+(SUMPRODUCT((Angebote!$B$14:$B$23>=DATE($D$7,H$11,1))*(Angebote!$B$14:$B$23<=DATE($D$7,H$11,31))*(Angebote!$P$14:$P$23=2)*(Angebote!$B$14:$B$23<>\"#NV\")))","v":0},{"$f":"(SUMPRODUCT((Angebote!$B$14:$B$23>=DATE($D$7,I$11,1))*(Angebote!$B$14:$B$23<=DATE($D$7,I$11,31))*(Angebote!$P$14:$P$23=1)*(Angebote!$B$14:$B$23<>\"#NV\")))+(SUMPRODUCT((Angebote!$B$14:$B$23>=DATE($D$7,I$11,1))*(Angebote!$B$14:$B$23<=DATE($D$7,I$11,31))*(Angebote!$P$14:$P$23=2)*(Angebote!$B$14:$B$23<>\"#NV\")))","v":0},{"$f":"(SUMPRODUCT((Angebote!$B$14:$B$23>=DATE($D$7,J$11,1))*(Angebote!$B$14:$B$23<=DATE($D$7,J$11,31))*(Angebote!$P$14:$P$23=1)*(Angebote!$B$14:$B$23<>\"#NV\")))+(SUMPRODUCT((Angebote!$B$14:$B$23>=DATE($D$7,J$11,1))*(Angebote!$B$14:$B$23<=DATE($D$7,J$11,31))*(Angebote!$P$14:$P$23=2)*(Angebote!$B$14:$B$23<>\"#NV\")))","v":0},{"$f":"(SUMPRODUCT((Angebote!$B$14:$B$23>=DATE($D$7,K$11,1))*(Angebote!$B$14:$B$23<=DATE($D$7,K$11,31))*(Angebote!$P$14:$P$23=1)*(Angebote!$B$14:$B$23<>\"#NV\")))+(SUMPRODUCT((Angebote!$B$14:$B$23>=DATE($D$7,K$11,1))*(Angebote!$B$14:$B$23<=DATE($D$7,K$11,31))*(Angebote!$P$14:$P$23=2)*(Angebote!$B$14:$B$23<>\"#NV\")))","v":0},{"$f":"(SUMPRODUCT((Angebote!$B$14:$B$23>=DATE($D$7,L$11,1))*(Angebote!$B$14:$B$23<=DATE($D$7,L$11,31))*(Angebote!$P$14:$P$23=1)*(Angebote!$B$14:$B$23<>\"#NV\")))+(SUMPRODUCT((Angebote!$B$14:$B$23>=DATE($D$7,L$11,1))*(Angebote!$B$14:$B$23<=DATE($D$7,L$11,31))*(Angebote!$P$14:$P$23=2)*(Angebote!$B$14:$B$23<>\"#NV\")))","v":0},{"$f":"(SUMPRODUCT((Angebote!$B$14:$B$23>=DATE($D$7,M$11,1))*(Angebote!$B$14:$B$23<=DATE($D$7,M$11,31))*(Angebote!$P$14:$P$23=1)*(Angebote!$B$14:$B$23<>\"#NV\")))+(SUMPRODUCT((Angebote!$B$14:$B$23>=DATE($D$7,M$11,1))*(Angebote!$B$14:$B$23<=DATE($D$7,M$11,31))*(Angebote!$P$14:$P$23=2)*(Angebote!$B$14:$B$23<>\"#NV\")))","v":0},{"$f":"(SUMPRODUCT((Angebote!$B$14:$B$23>=DATE($D$7,N$11,1))*(Angebote!$B$14:$B$23<=DATE($D$7,N$11,31))*(Angebote!$P$14:$P$23=1)*(Angebote!$B$14:$B$23<>\"#NV\")))+(SUMPRODUCT((Angebote!$B$14:$B$23>=DATE($D$7,N$11,1))*(Angebote!$B$14:$B$23<=DATE($D$7,N$11,31))*(Angebote!$P$14:$P$23=2)*(Angebote!$B$14:$B$23<>\"#NV\")))","v":0},{"$f":"(SUMPRODUCT((Angebote!$B$14:$B$23>=DATE($D$7,O$11,1))*(Angebote!$B$14:$B$23<=DATE($D$7,O$11,31))*(Angebote!$P$14:$P$23=1)*(Angebote!$B$14:$B$23<>\"#NV\")))+(SUMPRODUCT((Angebote!$B$14:$B$23>=DATE($D$7,O$11,1))*(Angebote!$B$14:$B$23<=DATE($D$7,O$11,31))*(Angebote!$P$14:$P$23=2)*(Angebote!$B$14:$B$23<>\"#NV\")))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q14+R14+S14+T14+U14+V14+W14+X14+Y14+Z14+AA14+AB14","v":2},null,null,{"$f":"IF(AQ14>=AY14,1,IF(AQ14>=AZ14,2,3))","v":3},{"$f":"AQ14","v":2},null,{"$f":"HLOOKUP(AT14,$BB$12:$BD$22,3)","v":"Handlungsanweisung für rot"},null,10,6,null,"Handlungsanweisung für grün","Handlungsanweisung für gelb","Handlungsanweisung für rot"]
[]
[null,null,"davon Auftagswert Folgeaufträge in T€",{"$f":"IF(Q14=0,\"\",Q16)","v":""},{"$f":"IF(R14=0,\"\",R16)","v":0},"","","","","","","","","","",null,{"$f":"SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,D$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,D$11,31))*(Angebote!$P$14:$P$24=2)*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$Q$14:$Q$24)","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,E$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,E$11,31))*(Angebote!$P$14:$P$24=2)*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$Q$14:$Q$24)","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,F$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,F$11,31))*(Angebote!$P$14:$P$24=2)*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$Q$14:$Q$24)","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,G$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,G$11,31))*(Angebote!$P$14:$P$24=2)*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$Q$14:$Q$24)","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,H$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,H$11,31))*(Angebote!$P$14:$P$24=2)*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$Q$14:$Q$24)","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,I$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,I$11,31))*(Angebote!$P$14:$P$24=2)*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$Q$14:$Q$24)","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,J$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,J$11,31))*(Angebote!$P$14:$P$24=2)*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$Q$14:$Q$24)","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,K$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,K$11,31))*(Angebote!$P$14:$P$24=2)*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$Q$14:$Q$24)","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,L$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,L$11,31))*(Angebote!$P$14:$P$24=2)*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$Q$14:$Q$24)","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,M$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,M$11,31))*(Angebote!$P$14:$P$24=2)*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$Q$14:$Q$24)","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,N$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,N$11,31))*(Angebote!$P$14:$P$24=2)*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$Q$14:$Q$24)","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,O$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,O$11,31))*(Angebote!$P$14:$P$24=2)*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$Q$14:$Q$24)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"IF(AQ16>=AY16,1,IF(AQ16>=AZ16,2,3))","v":3},{"$f":"AQ16","v":0},null,{"$f":"HLOOKUP(AT16,$BB$12:$BD$22,5)","v":"Handlungsanweisung für rot"},null,100,50,null,"Handlungsanweisung für grün","Handlungsanweisung für gelb","Handlungsanweisung für rot"]
[null,null,"davon Anzahl erhaltene Folgeaufträge",{"$f":"IF(Q14=0,\"\",Q17)","v":""},{"$f":"IF(R14=0,\"\",R17)","v":0},"","","","","","","","","","",null,{"$f":"SUMPRODUCT((Angebote!$B$14:$B$23>=DATE($D$7,D$11,1))*(Angebote!$B$14:$B$23<=DATE($D$7,D$11,31))*(Angebote!$P$14:$P$23=2)*(Angebote!$B$14:$B$23<>\"#NV\"))","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$23>=DATE($D$7,E$11,1))*(Angebote!$B$14:$B$23<=DATE($D$7,E$11,31))*(Angebote!$P$14:$P$23=2)*(Angebote!$B$14:$B$23<>\"#NV\"))","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$23>=DATE($D$7,F$11,1))*(Angebote!$B$14:$B$23<=DATE($D$7,F$11,31))*(Angebote!$P$14:$P$23=2)*(Angebote!$B$14:$B$23<>\"#NV\"))","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$23>=DATE($D$7,G$11,1))*(Angebote!$B$14:$B$23<=DATE($D$7,G$11,31))*(Angebote!$P$14:$P$23=2)*(Angebote!$B$14:$B$23<>\"#NV\"))","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$23>=DATE($D$7,H$11,1))*(Angebote!$B$14:$B$23<=DATE($D$7,H$11,31))*(Angebote!$P$14:$P$23=2)*(Angebote!$B$14:$B$23<>\"#NV\"))","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$23>=DATE($D$7,I$11,1))*(Angebote!$B$14:$B$23<=DATE($D$7,I$11,31))*(Angebote!$P$14:$P$23=2)*(Angebote!$B$14:$B$23<>\"#NV\"))","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$23>=DATE($D$7,J$11,1))*(Angebote!$B$14:$B$23<=DATE($D$7,J$11,31))*(Angebote!$P$14:$P$23=2)*(Angebote!$B$14:$B$23<>\"#NV\"))","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$23>=DATE($D$7,K$11,1))*(Angebote!$B$14:$B$23<=DATE($D$7,K$11,31))*(Angebote!$P$14:$P$23=2)*(Angebote!$B$14:$B$23<>\"#NV\"))","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$23>=DATE($D$7,L$11,1))*(Angebote!$B$14:$B$23<=DATE($D$7,L$11,31))*(Angebote!$P$14:$P$23=2)*(Angebote!$B$14:$B$23<>\"#NV\"))","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$23>=DATE($D$7,M$11,1))*(Angebote!$B$14:$B$23<=DATE($D$7,M$11,31))*(Angebote!$P$14:$P$23=2)*(Angebote!$B$14:$B$23<>\"#NV\"))","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$23>=DATE($D$7,N$11,1))*(Angebote!$B$14:$B$23<=DATE($D$7,N$11,31))*(Angebote!$P$14:$P$23=2)*(Angebote!$B$14:$B$23<>\"#NV\"))","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$23>=DATE($D$7,O$11,1))*(Angebote!$B$14:$B$23<=DATE($D$7,O$11,31))*(Angebote!$P$14:$P$23=2)*(Angebote!$B$14:$B$23<>\"#NV\"))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"IF(AQ17>=AY17,1,IF(AQ17>=AZ17,2,3))","v":3},{"$f":"AQ17","v":0},null,{"$f":"HLOOKUP(AT17,$BB$12:$BD$22,6)","v":"Handlungsanweisung für rot"},null,2,1,null,"Handlungsanweisung für grün","Handlungsanweisung für gelb","Handlungsanweisung für rot"]
[]
[null,null,"Angebotswert offene Angebote in T€",{"$f":"IF(Q20=0,\"\",Q19)","v":""},{"$f":"IF(R20=0,\"\",R19)","v":390},390,"","","","","","","","","",null,{"$f":"SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,D$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,D$11,31))*(Angebote!$P$14:$P$24=\"offen\")*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$K$14:$K$24)","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,E$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,E$11,31))*(Angebote!$P$14:$P$24=\"offen\")*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$K$14:$K$24)","v":390},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,F$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,F$11,31))*(Angebote!$P$14:$P$24=\"offen\")*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$K$14:$K$24)","v":390},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,G$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,G$11,31))*(Angebote!$P$14:$P$24=\"offen\")*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$K$14:$K$24)","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,H$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,H$11,31))*(Angebote!$P$14:$P$24=\"offen\")*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$K$14:$K$24)","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,I$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,I$11,31))*(Angebote!$P$14:$P$24=\"offen\")*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$K$14:$K$24)","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,J$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,J$11,31))*(Angebote!$P$14:$P$24=\"offen\")*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$K$14:$K$24)","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,K$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,K$11,31))*(Angebote!$P$14:$P$24=\"offen\")*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$K$14:$K$24)","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,L$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,L$11,31))*(Angebote!$P$14:$P$24=\"offen\")*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$K$14:$K$24)","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,M$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,M$11,31))*(Angebote!$P$14:$P$24=\"offen\")*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$K$14:$K$24)","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,N$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,N$11,31))*(Angebote!$P$14:$P$24=\"offen\")*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$K$14:$K$24)","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,O$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,O$11,31))*(Angebote!$P$14:$P$24=\"offen\")*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$K$14:$K$24)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,780,null,null,{"$f":"IF(AQ19>=AY19,1,IF(AQ19>=AZ19,2,3))","v":3},{"$f":"AQ19","v":780},null,{"$f":"HLOOKUP(AT19,$BB$12:$BD$22,8)","v":"Handlungsanweisung für rot"},null,900,800,null,"Handlungsanweisung für grün","Handlungsanweisung für gelb","Handlungsanweisung für rot"]
[null,null,"Anzahl offene Angebote",{"$f":"IF(Q20=0,\"\",Q20)","v":""},{"$f":"IF(R20=0,\"\",R20)","v":1},1,"","","","","","","","","",null,{"$f":"SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,D$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,D$11,31))*(Angebote!$P$14:$P$24=\"offen\")*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$S$14:$S$24)","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,E$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,E$11,31))*(Angebote!$P$14:$P$24=\"offen\")*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$S$14:$S$24)","v":1},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,F$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,F$11,31))*(Angebote!$P$14:$P$24=\"offen\")*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$S$14:$S$24)","v":1},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,G$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,G$11,31))*(Angebote!$P$14:$P$24=\"offen\")*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$S$14:$S$24)","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,H$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,H$11,31))*(Angebote!$P$14:$P$24=\"offen\")*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$S$14:$S$24)","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,I$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,I$11,31))*(Angebote!$P$14:$P$24=\"offen\")*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$S$14:$S$24)","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,J$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,J$11,31))*(Angebote!$P$14:$P$24=\"offen\")*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$S$14:$S$24)","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,K$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,K$11,31))*(Angebote!$P$14:$P$24=\"offen\")*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$S$14:$S$24)","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,L$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,L$11,31))*(Angebote!$P$14:$P$24=\"offen\")*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$S$14:$S$24)","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,M$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,M$11,31))*(Angebote!$P$14:$P$24=\"offen\")*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$S$14:$S$24)","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,N$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,N$11,31))*(Angebote!$P$14:$P$24=\"offen\")*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$S$14:$S$24)","v":0},{"$f":"SUMPRODUCT((Angebote!$B$14:$B$24>=DATE($D$7,O$11,1))*(Angebote!$B$14:$B$24<=DATE($D$7,O$11,31))*(Angebote!$P$14:$P$24=\"offen\")*(Angebote!$B$14:$B$24<>\"#NV\"),Angebote!$S$14:$S$24)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,{"$f":"IF(AQ20>=AY20,1,IF(AQ20>=AZ20,2,3))","v":1},{"$f":"AQ20","v":2},null,{"$f":"HLOOKUP(AT20,$BB$12:$BD$22,9)","v":"Handlungsanweisung für grün"},null,2,1,null,"Handlungsanweisung für grün","Handlungsanweisung für gelb","Handlungsanweisung für rot"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jan","jan","feb","feb","mrz","mrz","aprl","aprl","mai","mai","jun","jun","jul","jul","aug","aug","sept","sept","okt","okt","nov","nov"]
[null,null,"Auftragsquote",{"$f":"IF(Q14=0,\"\",IFERROR(S22/R22,0))","v":""},{"$f":"IF(R14=0,\"\",IFERROR(U22/T22,0))","v":0.66666666666666663},{"$f":"IF(S14=0,\"\",IFERROR(W22/V22,0))","v":""},{"$f":"IF(T14=0,\"\",IFERROR(Y22/X22,0))","v":""},{"$f":"IF(U14=0,\"\",IFERROR(AA22/Z22,0))","v":""},{"$f":"IF(V14=0,\"\",IFERROR(AC22/AB22,0))","v":""},{"$f":"IF(W14=0,\"\",IFERROR(AE22/AD22,0))","v":""},{"$f":"IF(X14=0,\"\",IFERROR(AG22/AF22,0))","v":""},{"$f":"IF(Y14=0,\"\",IFERROR(AI22/AH22,0))","v":""},{"$f":"IF(Z14=0,\"\",IFERROR(AK22/AJ22,0))","v":""},{"$f":"IF(AA14=0,\"\",IFERROR(AM22/AL22,0))","v":""},{"$f":"IF(AB14=0,\"\",IFERROR(AO22/AN22,0))","v":""},null,null,{"$f":"SUM(IF(YEAR(Angebote!$B$14:$B$23)=$D$7,IF(MONTH(Angebote!$B$14:$B$23)=$D$11,IF(Angebote!$P$14:$P$23<>2,1,))))","v":0},{"$f":"SUM(IF(YEAR(Angebote!$B$14:$B$23)=$D$7,IF(MONTH(Angebote!$B$14:$B$23)=$D$11,IF(Angebote!$P$14:$P$23=1,Angebote!$P$14:$P$23)*1,)))","v":0},{"$f":"SUM(IF(YEAR(Angebote!$B$14:$B$23)=$D$7,IF(MONTH(Angebote!$B$14:$B$23)=$E$11,IF(Angebote!$P$14:$P$23<>2,1,))))","v":3},{"$f":"SUM(IF(YEAR(Angebote!$B$14:$B$23)=$D$7,IF(MONTH(Angebote!$B$14:$B$23)=$E$11,IF(Angebote!$P$14:$P$23=1,Angebote!$P$14:$P$23)*1,)))","v":2},{"$f":"SUM(IF(YEAR(Angebote!$B$14:$B$23)=$D$7,IF(MONTH(Angebote!$B$14:$B$23)=$F$11,IF(Angebote!$P$14:$P$23<>2,1,))))","v":3},{"$f":"SUM(IF(YEAR(Angebote!$B$14:$B$23)=$D$7,IF(MONTH(Angebote!$B$14:$B$23)=$F$11,IF(Angebote!$P$14:$P$23=1,Angebote!$P$14:$P$23)*1,)))","v":0},{"$f":"SUM(IF(YEAR(Angebote!$B$14:$B$23)=$D$7,IF(MONTH(Angebote!$B$14:$B$23)=$G$11,IF(Angebote!$P$14:$P$23<>2,1,))))","v":0},{"$f":"SUM(IF(YEAR(Angebote!$B$14:$B$23)=$D$7,IF(MONTH(Angebote!$B$14:$B$23)=$G$11,IF(Angebote!$P$14:$P$23=1,Angebote!$P$14:$P$23)*1,)))","v":0},{"$f":"SUM(IF(YEAR(Angebote!$B$14:$B$23)=$D$7,IF(MONTH(Angebote!$B$14:$B$23)=$H$11,IF(Angebote!$P$14:$P$23<>2,1,))))","v":0},{"$f":"SUM(IF(YEAR(Angebote!$B$14:$B$23)=$D$7,IF(MONTH(Angebote!$B$14:$B$23)=$H$11,IF(Angebote!$P$14:$P$23=1,Angebote!$P$14:$P$23)*1,)))","v":0},{"$f":"SUM(IF(YEAR(Angebote!$B$14:$B$23)=$D$7,IF(MONTH(Angebote!$B$14:$B$23)=$I$11,IF(Angebote!$P$14:$P$23<>2,1,))))","v":0},{"$f":"SUM(IF(YEAR(Angebote!$B$14:$B$23)=$D$7,IF(MONTH(Angebote!$B$14:$B$23)=$I$11,IF(Angebote!$P$14:$P$23=1,Angebote!$P$14:$P$23)*1,)))","v":0},{"$f":"SUM(IF(YEAR(Angebote!$B$14:$B$23)=$D$7,IF(MONTH(Angebote!$B$14:$B$23)=$J$11,IF(Angebote!$P$14:$P$23<>2,1,))))","v":0},{"$f":"SUM(IF(YEAR(Angebote!$B$14:$B$23)=$D$7,IF(MONTH(Angebote!$B$14:$B$23)=$J$11,IF(Angebote!$P$14:$P$23=1,Angebote!$P$14:$P$23)*1,)))","v":0},{"$f":"SUM(IF(YEAR(Angebote!$B$14:$B$23)=$D$7,IF(MONTH(Angebote!$B$14:$B$23)=$K$11,IF(Angebote!$P$14:$P$23<>2,1,))))","v":0},{"$f":"SUM(IF(YEAR(Angebote!$B$14:$B$23)=$D$7,IF(MONTH(Angebote!$B$14:$B$23)=$K$11,IF(Angebote!$P$14:$P$23=1,Angebote!$P$14:$P$23)*1,)))","v":0},{"$f":"SUM(IF(YEAR(Angebote!$B$14:$B$23)=$D$7,IF(MONTH(Angebote!$B$14:$B$23)=$L$11,IF(Angebote!$P$14:$P$23<>2,1,))))","v":0},{"$f":"SUM(IF(YEAR(Angebote!$B$14:$B$23)=$D$7,IF(MONTH(Angebote!$B$14:$B$23)=$L$11,IF(Angebote!$P$14:$P$23=1,Angebote!$P$14:$P$23)*1,)))","v":0},{"$f":"SUM(IF(YEAR(Angebote!$B$14:$B$23)=$D$7,IF(MONTH(Angebote!$B$14:$B$23)=$M$11,IF(Angebote!$P$14:$P$23<>2,1,))))","v":0},{"$f":"SUM(IF(YEAR(Angebote!$B$14:$B$23)=$D$7,IF(MONTH(Angebote!$B$14:$B$23)=$M$11,IF(Angebote!$P$14:$P$23=1,Angebote!$P$14:$P$23)*1,)))","v":0},{"$f":"SUM(IF(YEAR(Angebote!$B$14:$B$23)=$D$7,IF(MONTH(Angebote!$B$14:$B$23)=$N$11,IF(Angebote!$P$14:$P$23<>2,1,))))","v":0},{"$f":"SUM(IF(YEAR(Angebote!$B$14:$B$23)=$D$7,IF(MONTH(Angebote!$B$14:$B$23)=$N$11,IF(Angebote!$P$14:$P$23=1,Angebote!$P$14:$P$23)*1,)))","v":0},{"$f":"SUM(IF(YEAR(Angebote!$B$14:$B$23)=$D$7,IF(MONTH(Angebote!$B$14:$B$23)=$O$11,IF(Angebote!$P$14:$P$23<>2,1,))))","v":0},{"$f":"SUM(IF(YEAR(Angebote!$B$14:$B$23)=$D$7,IF(MONTH(Angebote!$B$14:$B$23)=$O$11,IF(Angebote!$P$14:$P$23=1,Angebote!$P$14:$P$23)*1,)))","v":0},null,{"$f":"IFERROR(AS22/AR22,0)","v":0.33333333333333331},{"$f":"SUM(IF(YEAR(Angebote!$B$14:$B$23)=$D$7,IF(Angebote!$P$14:$P$23<>2,1,)))","v":6},{"$f":"SUM(IF(YEAR(Angebote!$B$14:$B$23)=$D$7,IF(Angebote!$P$14:$P$23=1,Angebote!$P$14:$P$23)*1,))","v":2},{"$f":"IF(AQ22>=AY22,1,IF(AQ22>=AZ22,2,3))","v":3},{"$f":"AQ22","v":0.33333333333333331},null,{"$f":"HLOOKUP(AT22,$BB$12:$BD$22,11)","v":"Handlungsanweisung für rot"},null,0.8,0.6,null,"Handlungsanweisung für grün","Handlungsanweisung für gelb","Handlungsanweisung für rot"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,{"$f":"DATE($D$7,1,1)","v":"2016-01-01"},{"$f":"DATE($D$7,2,1)","v":"2016-02-01"},{"$f":"DATE($D$7,3,1)","v":"2016-03-01"},{"$f":"DATE($D$7,4,1)","v":"2016-04-01"},{"$f":"DATE($D$7,5,1)","v":"2016-05-01"},{"$f":"DATE($D$7,6,1)","v":"2016-06-01"},{"$f":"DATE($D$7,7,1)","v":"2016-07-01"},{"$f":"DATE($D$7,8,1)","v":"2016-08-01"},{"$f":"DATE($D$7,9,1)","v":"2016-09-01"},{"$f":"DATE($D$7,10,1)","v":"2016-10-01"},{"$f":"DATE($D$7,11,1)","v":"2016-11-01"},{"$f":"DATE($D$7,12,1)","v":"2016-12-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"Chefinfo Auftragsübersicht",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jahr",null,null,1,null,null,null,null,"Grenzwerte",null,null,"Handlungsanweisungen"]
[null,null,null,{"$f":"MONTH(D25)","v":1},{"$f":"MONTH(E25)","v":2},3,4,5,6,7,8,9,10,11,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,"Jan","Feb","Mrz","Apr","Mai","Jun","Jul","Aug","Sept","Okt","Nov","Dez",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kum.",null,null,1,null,null,null,null,">= grün",">= gelb","rot",1,2,3]
[null,null,"Prozent im Monat",{"$f":"IF(Q$30=0,\"\",Q29)","v":""},{"$f":"IF(R$30=0,\"\",R29)","v":0.93314663023679423},"","","","","","","","","","",null,{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,D$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,D$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),Aufträge!$AJ$15:$AJ$24)","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,E$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,E$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),Aufträge!$AJ$15:$AJ$24)","v":0.93314663023679423},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,F$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,F$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),Aufträge!$AJ$15:$AJ$24)","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,G$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,G$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),Aufträge!$AJ$15:$AJ$24)","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,H$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,H$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),Aufträge!$AJ$15:$AJ$24)","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,I$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,I$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),Aufträge!$AJ$15:$AJ$24)","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,J$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,J$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),Aufträge!$AJ$15:$AJ$24)","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,K$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,K$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),Aufträge!$AJ$15:$AJ$24)","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,L$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,L$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),Aufträge!$AJ$15:$AJ$24)","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,M$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,M$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),Aufträge!$AJ$15:$AJ$24)","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,N$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,N$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),Aufträge!$AJ$15:$AJ$24)","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,O$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,O$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),Aufträge!$AJ$15:$AJ$24)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D29+E29+F29+G29+H29+I29+J29+K29+L29+M29+N29+O29","v":{"$error":"#VALUE!"}},null,null,{"$error":"#VALUE!"},{"$f":"AQ29","v":{"$error":"#VALUE!"}},null,{"$f":"HLOOKUP(AT29,$BB$12:$BD$22,2)","v":{"$error":"#VALUE!"}},null,2000,500,null,"Handlungsanweisung für grün","Handlungsanweisung für gelb","Handlungsanweisung für rot"]
[null,null,"Anzahl Aufträge ",{"$f":"IF(Q$30=0,\"\",Q30)","v":""},2,"","","","","","","","","","",null,{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,D$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,D$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\")*(Aufträge!$B$15:$B$24>0))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,E$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,E$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\")*(Aufträge!$B$15:$B$24>0))","v":2},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,F$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,F$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\")*(Aufträge!$B$15:$B$24>0))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,G$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,G$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\")*(Aufträge!$B$15:$B$24>0))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,H$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,H$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\")*(Aufträge!$B$15:$B$24>0))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,I$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,I$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\")*(Aufträge!$B$15:$B$24>0))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,J$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,J$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\")*(Aufträge!$B$15:$B$24>0))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,K$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,K$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\")*(Aufträge!$B$15:$B$24>0))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,L$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,L$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\")*(Aufträge!$B$15:$B$24>0))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,M$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,M$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\")*(Aufträge!$B$15:$B$24>0))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,N$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,N$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\")*(Aufträge!$B$15:$B$24>0))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,O$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,O$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\")*(Aufträge!$B$15:$B$24>0))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D30+E30+F30+G30+H30+I30+J30+K30+L30+M30+N30+O30","v":{"$error":"#VALUE!"}},null,null,{"$error":"#VALUE!"},{"$f":"AQ30","v":{"$error":"#VALUE!"}},null,{"$f":"HLOOKUP(AT30,$BB$28:$BD$37,3)","v":{"$error":"#VALUE!"}},null,10,6,null,"Handlungsanweisung für grün","Handlungsanweisung für gelb","Handlungsanweisung für rot"]
[null,null,"nicht abgerechnete Aufträge in T€","",485,"","","","","","","","","","",null,{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,D$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,D$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$O$15:$O$24))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,E$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,E$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$O$15:$O$24))","v":485},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,F$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,F$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$O$15:$O$24))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,G$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,G$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$O$15:$O$24))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,H$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,H$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$O$15:$O$24))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,I$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,I$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$O$15:$O$24))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,J$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,J$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$O$15:$O$24))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,K$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,K$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$O$15:$O$24))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,L$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,L$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$O$15:$O$24))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,M$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,M$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$O$15:$O$24))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,N$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,N$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$O$15:$O$24))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,O$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,O$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$O$15:$O$24))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q31+R31+S31+T31+U31+V31+W31+X31+Y31+Z31+AA31+AB31","v":485},null,null,2,{"$f":"AQ31","v":485},null,{"$f":"HLOOKUP(AT31,$BB$28:$BD$37,4)","v":"Handlungsanweisung für gelb"},null,1000,400,null,"Handlungsanweisung für grün","Handlungsanweisung für gelb","Handlungsanweisung für rot"]
[null,null,"TF Arbeiten fertiggestellt %","",0,"","","","","","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(D32+E32+F32+G32+H32+I32+J32+K32+L32+M32+N32+O32)/AR32","v":{"$error":"#VALUE!"}},{"$f":"COUNTIF(D32:O32,\">0\")","v":0},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$f":"HLOOKUP(AT32,$BB$28:$BD$37,5)","v":{"$error":"#VALUE!"}},null,0.5,0.3,null,"Handlungsanweisung für grün","Handlungsanweisung für gelb","Handlungsanweisung für rot"]
[null,null,"Fertigstellungsstand %","",0.49525773195876288,"","","","","","","","","","",null,{"$f":"IFERROR((SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,D$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,D$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AL$15:$AL$24)))/(SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,D$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,D$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$O$15:$O$24))),0)","v":0},{"$f":"IFERROR((SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,E$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,E$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AL$15:$AL$24)))/(SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,E$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,E$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$O$15:$O$24))),0)","v":0.49525773195876288},{"$f":"IFERROR((SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,F$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,F$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AL$15:$AL$24)))/(SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,F$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,F$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$O$15:$O$24))),0)","v":0},{"$f":"IFERROR((SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,G$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,G$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AL$15:$AL$24)))/(SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,G$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,G$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$O$15:$O$24))),0)","v":0},{"$f":"IFERROR((SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,H$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,H$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AL$15:$AL$24)))/(SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,H$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,H$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$O$15:$O$24))),0)","v":0},{"$f":"IFERROR((SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,I$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,I$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AL$15:$AL$24)))/(SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,I$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,I$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$O$15:$O$24))),0)","v":0},{"$f":"IFERROR((SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,J$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,J$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AL$15:$AL$24)))/(SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,J$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,J$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$O$15:$O$24))),0)","v":0},{"$f":"IFERROR((SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,K$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,K$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AL$15:$AL$24)))/(SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,K$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,K$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$O$15:$O$24))),0)","v":0},{"$f":"IFERROR((SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,L$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,L$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AL$15:$AL$24)))/(SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,L$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,L$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$O$15:$O$24))),0)","v":0},{"$f":"IFERROR((SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,M$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,M$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AL$15:$AL$24)))/(SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,M$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,M$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$O$15:$O$24))),0)","v":0},{"$f":"IFERROR((SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,N$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,N$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AL$15:$AL$24)))/(SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,N$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,N$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$O$15:$O$24))),0)","v":0},{"$f":"IFERROR((SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,O$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,O$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AL$15:$AL$24)))/(SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,O$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,O$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$O$15:$O$24))),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((SUMPRODUCT((YEAR(Angebote!$B$14:$B$23)=$D$7)*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AL$15:$AL$24)))/(SUMPRODUCT((YEAR(Angebote!$B$14:$B$23)=$D$7)*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$O$15:$O$24))),0)","v":0.49525773195876288},null,null,3,0.49525773195876288,null,{"$f":"HLOOKUP(AT33,$BB$28:$BD$37,6)","v":"Handlungsanweisung für rot"},null,0.8,0.6,null,"Handlungsanweisung für grün","Handlungsanweisung für gelb","Handlungsanweisung für rot"]
[null,null,"TF Arbeiten Bestand in T€","",240.2,"","","","","","","","","","",null,{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,D$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,D$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AL$15:$AL$24))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,E$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,E$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AL$15:$AL$24))","v":240.2},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,F$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,F$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AL$15:$AL$24))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,G$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,G$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AL$15:$AL$24))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,H$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,H$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AL$15:$AL$24))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,I$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,I$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AL$15:$AL$24))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,J$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,J$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AL$15:$AL$24))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,K$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,K$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AL$15:$AL$24))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,L$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,L$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AL$15:$AL$24))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,M$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,M$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AL$15:$AL$24))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,N$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,N$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AL$15:$AL$24))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,O$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,O$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AL$15:$AL$24))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q34+R34+S34+T34+U34+V34+W34+X34+Y34+Z34+AA34+AB34","v":240.2},null,null,2,240.2,null,{"$f":"HLOOKUP(AT34,$BB$28:$BD$37,7)","v":"Handlungsanweisung für gelb"},null,500,200,null,"Handlungsanweisung für grün","Handlungsanweisung für gelb","Handlungsanweisung für rot"]
[null,null,null,{"$f":"IFERROR(D36/D34,-1)","v":-1},{"$f":"IFERROR(E36/E34,-1)","v":0.62447960033305583},-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,null,{"$f":"IFERROR(Q36/Q34,-1)","v":-1},{"$f":"IFERROR(R36/R34,-1)","v":0.62447960033305583},{"$f":"IFERROR(S36/S34,-1)","v":-1},{"$f":"IFERROR(T36/T34,-1)","v":-1},{"$f":"IFERROR(U36/U34,-1)","v":-1},{"$f":"IFERROR(V36/V34,-1)","v":-1},{"$f":"IFERROR(W36/W34,-1)","v":-1},{"$f":"IFERROR(X36/X34,-1)","v":-1},{"$f":"IFERROR(Y36/Y34,-1)","v":-1},{"$f":"IFERROR(Z36/Z34,-1)","v":-1},{"$f":"IFERROR(AA36/AA34,-1)","v":-1},{"$f":"IFERROR(AB36/AB34,-1)","v":-1},{"$f":"IFERROR(AC36/AC34,-1)","v":-1},{"$f":"IFERROR(AD36/AD34,-1)","v":-1},{"$f":"IFERROR(AE36/AE34,-1)","v":-1},{"$f":"IFERROR(AF36/AF34,-1)","v":-1},{"$f":"IFERROR(AG36/AG34,-1)","v":-1},{"$f":"IFERROR(AH36/AH34,-1)","v":-1},{"$f":"IFERROR(AI36/AI34,-1)","v":-1},{"$f":"IFERROR(AJ36/AJ34,-1)","v":-1},{"$f":"IFERROR(AK36/AK34,-1)","v":-1},{"$f":"IFERROR(AL36/AL34,-1)","v":-1},{"$f":"IFERROR(AM36/AM34,-1)","v":-1},null,null,{"$f":"IFERROR(AP36/AP34,-1)","v":-1},{"$f":"IFERROR(AQ36/AQ34,-1)","v":0.62447960033305583},null,null,1]
[null,null,"gestellte TR in T€",{"$f":"IF(Q$30=0,\"\",Q36)","v":""},{"$f":"IF(R$30=0,\"\",R36)","v":150},"","","","","","","","","","",null,{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,D$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,D$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AB$15:$AB$24))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,E$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,E$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AB$15:$AB$24))","v":150},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,F$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,F$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AB$15:$AB$24))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,G$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,G$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AB$15:$AB$24))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,H$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,H$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AB$15:$AB$24))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,I$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,I$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AB$15:$AB$24))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,J$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,J$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AB$15:$AB$24))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,K$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,K$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AB$15:$AB$24))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,L$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,L$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AB$15:$AB$24))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,M$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,M$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AB$15:$AB$24))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,N$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,N$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AB$15:$AB$24))","v":0},{"$f":"SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,O$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,O$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AB$15:$AB$24))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q36+R36+S36+T36+U36+V36+W36+X36+Y36+Z36+AA36+AB36","v":150},null,null,{"$f":"IF(AQ35>=AY36,1,IF(AQ35>=AZ36,2,3))","v":3},{"$f":"AQ35","v":0.62447960033305583},null,{"$f":"HLOOKUP(AT36,$BB$28:$BD$37,9)","v":"Handlungsanweisung für rot"},null,{"$f":"Einrichtung!C33","v":0.7},{"$f":"AY36-5%","v":0.64999999999999991},null,"Handlungsanweisung für grün","Handlungsanweisung für gelb","Handlungsanweisung für rot"]
[null,null,"Auslastung in Std.",{"$f":"IF(Q$30=0,\"\",Q37)","v":""},{"$f":"IF(R$30=0,\"\",R37)","v":3956.5761689291103},"","","","","","","","","","",null,{"$f":"((SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,D$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,D$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AR$15:$AR$24))))","v":0},{"$f":"((SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,E$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,E$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AR$15:$AR$24))))","v":3956.5761689291103},{"$f":"((SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,F$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,F$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AR$15:$AR$24))))","v":0},{"$f":"((SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,G$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,G$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AR$15:$AR$24))))","v":0},{"$f":"((SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,H$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,H$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AR$15:$AR$24))))","v":0},{"$f":"((SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,I$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,I$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AR$15:$AR$24))))","v":0},{"$f":"((SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,J$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,J$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AR$15:$AR$24))))","v":0},{"$f":"((SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,K$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,K$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AR$15:$AR$24))))","v":0},{"$f":"((SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,L$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,L$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AR$15:$AR$24))))","v":0},{"$f":"((SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,M$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,M$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AR$15:$AR$24))))","v":0},{"$f":"((SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,N$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,N$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AR$15:$AR$24))))","v":0},{"$f":"((SUMPRODUCT((Aufträge!$B$15:$B$24>=DATE($D$7,O$11,1))*(Aufträge!$B$15:$B$24<=DATE($D$7,O$11,31))*(Aufträge!$B$15:$B$24<>\"#NV\"),(Aufträge!$AR$15:$AR$24))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,3956.5761689291103,null,null,1,{"$f":"AQ37","v":3956.5761689291103},null,{"$f":"HLOOKUP(AT37,$BB$28:$BD$37,10)","v":"Handlungsanweisung für grün"},null,2,1,null,"Handlungsanweisung für grün","Handlungsanweisung für gelb","Handlungsanweisung für rot"]

{"sheet":"Angebote","index":3,"n_rows":42,"n_cols":26,"rows_kept":42,"cut":false,"hidden":false,"merged":[[10,15,10,17],[10,0,10,12],[11,10,12,10],[11,9,12,9],[11,0,12,0],[11,16,12,16]]}
[]
["Auftragsplanung | Angebotsübersicht",null,null,null,null,null,null,{"$f":"TODAY()","v":"2016-08-09"}]
[]
[{"$f":"Start!AA4&\"      \"&\"Erfassungsdatum: \"&TEXT(Start!E16,\"TT.MM.JJJJ\")&\"     \"&\"für Monat: \"&TEXT(Start!AA46,\"MM/JJJJ\")&\"       \"&\"erfasst von: \"&TEXT(Start!E17,\"\")","v":"Firma:  Mustermann GmbH      Erfassungsdatum: 10.05.2016     für Monat: 04/2016       erfasst von: Max Muster"}]
[null,null,null,null,null,null,null,null,null,"privat"]
[null,null,null,null,null,null,null,null,null,"gewerblich"]
[null,null,null,null,null,null,null,null,null,"Architekt"]
[null,null,null,null,null,null,null,null,null,"Bauträger"]
[null,null,null,null,null,null,null,null,null,"öffentl. Hand"]
[null,null,null,null,null,null,null,null,null,"sonstige"]
["Angebotsübersicht",null,null,null,null,null,null,null,null,null,null,null,null,null,"Angebotsstatus","Angebotsstatus"]
["lfd. Nr.",null,null,null,null,null,null,null,null,"Angebots-wert in \nT€","Angebote offen in \nT€",null,null,null,null,null,"Auftrags\n-wert in T€"]
[null,"Angebots-  datum","Angebots\nNr.","Auftraggeber","Herkunft","Bau-\nvorhaben","Produkt-\nbereich","Ort","Telefon",null,null,"Ausführungs-zeitraum","Entscheidungs-zeitraum",null,"    Entschei-\ndungsstatus","Status",null,"Kommentar"]
[1,"2016-02-01",15477,"Fa. Maier","gewerblich","Einkaufsmarkt","Gewerbebau","München",null,300,{"$f":"IF(P14=\"offen\",J14,\"\")","v":""},"2016-04-01","2016-03-01","=",null,1,{"$f":"IF(OR(P14=1,P14=2),J14,\"\")","v":300},null,{"$f":"IF(P14=\"offen\",1,0)","v":0},{"$f":"Einrichtung!B13","v":"Neubau-Privatkd."},{"$f":"IF(P14=1,J14,0)","v":300},null,"offen"]
[2,"2016-02-15",15478,"Fa. Huber","Architekt","Hallen","Gewerbebau","Rosenheim",null,240,{"$f":"IF(P15=\"offen\",J15,\"\")","v":""},"Mai","2016-04-01",null,null,0,{"$f":"IF(OR(P15=1,P15=2),J15,\"\")","v":""},"zu teuer-5%, Fa. Mittermeier hats bekommen!",{"$f":"IF(P15=\"offen\",1,0)","v":0},{"$f":"Einrichtung!B14","v":"Gewerbebau"},null,null,0]
[3,"2016-02-20",15479,"Herr Staber","privat","EFH","Neubau-Privatkd.","Ampfing",null,180,"","Mai","2016-04-01",null,null,1,180,null,0,{"$f":"Einrichtung!B15","v":"Renovierung"},null,null,1]
[4,"2016-03-01",15479,"Fa. Müller","Bauträger","MFH","Bauträger","Wasserburg",null,390,390,"2016-06-01","2016-04-01",null,null,{"$f":"IF(J17<>\"\",\"offen\",\"\")","v":"offen"},"",null,1,{"$f":"Einrichtung!B16","v":"Umbau"},null,null,2]
[5,"2016-03-15",null,"Fa. Müller","Bauträger","MFH","Bauträger","Wasserburg",null,420,"","2016-06-01","2016-04-01",null,null,3,"",null,0,{"$f":"Einrichtung!B17","v":"Bauträger"},null,null,3]
[6,"2016-03-18",15480,"Herr Winter","privat","EFH","Umbau","Mühldorf",null,100,"","2016-10-01","April",null,null,"versch.","","soll im Dezember 16 entschieden werden",0,null,null,null,"versch."]
[7,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","",null,0]
[8,null,null,null,null,null,null,null,null,null,"",null,null,null,null,{"$f":"IF(J21<>\"\",\"offen\",\"\")","v":""},"",null,0]
[9,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","",null,0]
[10,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"offen",0,1,2,"versch."]
[null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(2,K14:K23)&\" offene Angebote mit einem Angebotswert von T€\"","v":"0 offene Angebote mit einem Angebotswert von T€"},{"$f":"SUBTOTAL(9,K14:K23)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF($P$14:$P$23=\"offen\",1))","v":1},{"$f":"SUM(IF($P$14:$P$23=0,1))","v":1},{"$f":"SUM(IF($P$14:$P$23=1,1))","v":2},{"$f":"SUM(IF($P$14:$P$23=2,1))","v":0},{"$f":"SUM(IF($P$14:$P$23=\"versch.\",1))","v":1}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 erhaltene Aufträge mit einem Auftragswert von TE",{"$f":"X27&\" erhaltene Folgeaufträge mit einem Auftragswert von T€\"","v":"0 erhaltene Folgeaufträge mit einem Auftragswert von T€"},{"$f":"SUMPRODUCT(SUBTOTAL(9,INDIRECT(\"Q\"&ROW(14:23)))*(P14:P23=2))","v":0},null,null,null,null,null,null,{"$f":"SUMPRODUCT(SUBTOTAL(3,INDIRECT(\"P\"&ROW(14:23)))*(P14:P23=2))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ges"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X29 &\" erhaltene Aufträge mit einem Auftragswert von T€\"","v":"2 erhaltene Aufträge mit einem Auftragswert von T€"},{"$f":"SUMPRODUCT(SUBTOTAL(9,INDIRECT(\"Q\"&ROW(14:23)))*(P14:P23=1))","v":480},null,null,null,null,{"$f":"SUBTOTAL(2,J14:J23)-Y25","v":3},{"$f":"SUM(IF($P$14:$P$23=1,1))","v":2},{"$f":"SUMPRODUCT(SUBTOTAL(3,INDIRECT(\"P\"&ROW(14:23)))*(P14:P23=1))","v":2}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auftragsquote nach Spaltenfilter",{"$f":"SUBTOTAL(2,Q14:Q23)/SUBTOTAL(2,J14:J23)","v":0.66666666666666663}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jahr","quote","Angebote","Anzahl Aufträge"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Auftragsquote",null,null,2016,{"$f":"U42/V42","v":0.33333333333333331},null,null,null,2011,{"$f":"IF($W$33=0,\"-\",$X$33/$W$33)","v":{"$error":"#VALUE!"}},{"$f":"SUM(IF(YEAR($B$14:$B$23)=$P$33,IF($P$14:$P$23<>2,1,)))","v":6},{"$f":"SUM(IF(YEAR($B$14:$B$23)=$P$33,IF($J$14:$J$23>0,$P$14:$P$23)*1,))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2012,{"$f":"IF($W$33=0,\"-\",$X$33/$W$33)","v":{"$error":"#VALUE!"}},{"$f":"SUM(IF(YEAR($B$14:$B$23)=$P$33,IF($P$14:$P$23<>2,1,)))","v":6},{"$f":"SUM(IF(YEAR($B$14:$B$23)=$P$33,IF($P$14:$P$23=1,$P$14:$P$23)*1,))","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2013,{"$f":"IF($W$33=0,\"-\",$X$33/$W$33)","v":{"$error":"#VALUE!"}},{"$f":"SUM(IF(YEAR($B$14:$B$23)=$P$33,IF($P$14:$P$23<>2,1,)))","v":6},{"$f":"SUM(IF(YEAR($B$14:$B$23)=$P$33,IF($P$14:$P$23=1,$P$14:$P$23)*1,))","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"YEAR(TODAY())-2","v":2014},{"$f":"IF($W$33=0,\"-\",$X$33/$W$33)","v":{"$error":"#VALUE!"}},{"$f":"SUM(IF(YEAR($B$14:$B$23)=$P$33,IF($P$14:$P$23<>2,1,)))","v":6},{"$f":"SUM(IF(YEAR($B$14:$B$23)=$P$33,IF($P$14:$P$23=1,$P$14:$P$23)*1,))","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"YEAR(TODAY())-1","v":2015},{"$f":"IF($W$33=0,\"-\",$X$33/$W$33)","v":{"$error":"#VALUE!"}},{"$f":"SUM(IF(YEAR($B$14:$B$23)=$P$33,IF($P$14:$P$23<>2,1,)))","v":6},{"$f":"SUM(IF(YEAR($B$14:$B$23)=$P$33,IF($P$14:$P$23=1,$P$14:$P$23)*1,))","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"YEAR(TODAY())","v":2016},{"$f":"IF($W$33=0,\"-\",$X$33/$W$33)","v":{"$error":"#VALUE!"}},{"$f":"SUM(IF(YEAR($B$14:$B$23)=$P$33,IF($P$14:$P$23<>2,1,)))","v":6},{"$f":"SUM(IF(YEAR($B$14:$B$23)=$P$33,IF($P$14:$P$23=1,$P$14:$P$23)*1,))","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"YEAR(TODAY())+1","v":2017},{"$error":"#VALUE!"},{"$f":"SUM(IF(YEAR($B$14:$B$23)=$P$33,IF($P$14:$P$23<>2,1,)))","v":6},{"$f":"SUM(IF(YEAR($B$14:$B$23)=$P$33,IF($P$14:$P$23=1,$P$14:$P$23)*1,))","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"YEAR(TODAY())+2","v":2018},{"$error":"#VALUE!"},{"$f":"SUM(IF(YEAR($B$14:$B$23)=$P$33,IF($P$14:$P$23<>2,1,)))","v":6},{"$f":"SUM(IF(YEAR($B$14:$B$23)=$P$33,IF($P$14:$P$23=1,$P$14:$P$23)*1,))","v":2}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(($B$14:$B$24>=DATE($P$33,1,1))*($B$14:$B$24<=DATE($P$33,12,31))*($B$14:$B$24<>\"#NV\")*($P$14:$P$24=1))+SUMPRODUCT(($B$14:$B$24>=DATE($P$33,1,1))*($B$14:$B$24<=DATE($P$33,12,31))*($B$14:$B$24<>\"#NV\")*($P$14:$P$24=2))","v":2},{"$f":"SUMPRODUCT(($B$14:$B$24>=DATE($P$33,1,1))*($B$14:$B$24<=DATE($P$33,12,31))*($B$14:$B$24<>\"#NV\"))","v":6}]

{"sheet":"Aufträge","index":4,"n_rows":42,"n_cols":44,"rows_kept":42,"cut":false,"hidden":false,"merged":[[33,26,33,27],[6,39,6,40],[8,39,8,40],[10,29,10,31],[10,20,10,22],[10,37,10,40],[10,23,10,24],[10,25,10,26],[9,17,9,26],[10,17,10,19],[9,37,9,40],[11,17,11,19],[11,20,11,22],[11,23,11,24],[11,25,11,26],[9,11,9,13],[9,0,9,10],[10,11,10,13],[27,26,27,27],[31,26,31,27],[29,26,29,27],[12,18,12,19]]}
[]
["Auftragsplanung | Auftragsübersicht"]
[]
[{"$f":"Start!AA4&\"      \"&\"Erfassungsdatum: \"&TEXT(Start!E16,\"TT.MM.JJJJ\")&\"     \"&\"für Monat: \"&TEXT(Start!AA46,\"MM/JJJJ\")&\"       \"&\"erfasst von: \"&TEXT(Start!E17,\"\")","v":"Firma:  Mustermann GmbH      Erfassungsdatum: 10.05.2016     für Monat: 04/2016       erfasst von: Max Muster"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ja"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Start!R28","v":42461}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auftragswerte - Produktionsstand"]
["Auftragsübersicht",null,null,null,null,null,null,null,null,null,null,"Abschlussrechnung",null,null,null,null,null,"Bewertung der Leistung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bewertung teilfertige"]
[null,null,null,null,null,null,null,null,null,null,"korr.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Istwerte",null,null,null,null,null,null,null,"Arbeiten in T€"]
[null,null,null,null,null,null,null,null,"Auftrags-","Regie/","Auftrags-",null,null,null,"Aufträge ",null,null,"Materialverbrauch",null,null,"Lohnkosten",null,null,"Fertigungsstand",null,"Fremdleistungen"]
["lfd.","Angebots-","Auftrags-","Auftrag-","Bau-","Produkt-",null,"Fertig-","wert in ","Nachträge ","wert in ","Re.","Betrag","bezahlt","nicht",null,"Plan","Plan","IST",null,"Plan","Plan","Plan","IST","IST","Plan","IST","gestellte","Stand","Material ","Fertigstellungsstand","Fremdleist.",null,null,null,null,null,null,"Auftragswert"]
["Nr.","datum","nummer","geber","vorhaben","bereich","Beginn","stellung","T€","in T€","T€","Datum","in T€ ",null,"abgr.",null," in %"," in T€ "," in %","In T€","Std.Satz","in T€","in std.","in %","in Std."," in T€","in T€","TR in T€","Std.","in T€"," in T€ "," in T€",null,null,null,null,null,"TF- Arb.","abrechenbar","TR","Differenz"]
[{"$f":"Angebote!A14","v":1},{"$f":"IF(OR(Angebote!$P14=1,Angebote!$P14=2),Angebote!B14,\"\")","v":"2016-02-01"},{"$f":"IF(OR(Angebote!$P14=1,Angebote!$P14=2),Angebote!C14,\"\")","v":15477},{"$f":"IF(OR(Angebote!$P14=1,Angebote!$P14=2),Angebote!D14,\"\")","v":"Fa. Maier"},{"$f":"IF(OR(Angebote!$P14=1,Angebote!$P14=2),Angebote!F14,\"\")","v":"Einkaufsmarkt"},{"$f":"IF(OR(Angebote!$P14=1,Angebote!$P14=2),Angebote!G14,\"\")","v":"Gewerbebau"},"2016-04-01","2016-05-30",{"$f":"IF(OR(Angebote!$P14=1,Angebote!$P14=2),Angebote!Q14,\"\")","v":300},5,{"$f":"IF(J15<>0,I15+J15,I15)","v":305},null,null,null,{"$f":"IF(M15=\"\",K15,\"\")","v":305},null,{"$f":"IF(F15=\"\",\"\",VLOOKUP(F15,Einrichtung!$B$13:$E$17,2,0))","v":0.35},{"$f":"IF(K15=\"\",\"\",Q15*K15)","v":106.75},1,null,{"$f":"IF(F15=\"\",\"\",VLOOKUP(F15,Einrichtung!$B$13:$E$17,4,0))","v":39},{"$f":"IF(W15=\"\",\"\",(U15*W15)/1000)","v":167.75000000000003},{"$f":"IF(K15=\"\",\"\",(K15-R15-Z15)/(U15/1000))","v":4301.2820512820517},null,1000,{"$f":"IF(F15=\"\",\"\",VLOOKUP(F15,Einrichtung!$B$13:$E$17,3,0)*K15)","v":30.5},30.5,100,{"$f":"IF(AND(U15=\"\",Y15=\"\"),\"\",IF(Y15>W15,U15*W15/1000,Y15*U15/1000))","v":39},{"$f":"IF(R15=\"\",\"\",IF(S15>0,R15*S15,T15))","v":106.75},{"$f":"IF(AND(X15=\"\",Y15=\"\",),\"\",IF(Y15>0,U15*Y15/1000,(U15*W15)/1000*X15))","v":39},{"$f":"IF(Z15=0,\"0\",AA15)","v":30.5},{"$f":"AB15/O15","v":0.32786885245901637},null,{"$f":"IF(M15>0,1,AJ15)","v":0.57786885245901642},{"$f":"IFERROR(AL15/K15,0)","v":0.57786885245901642},null,{"$f":"IF(AND(L15=\"\",AD15<>\"\"),AD15+AE15+AF15,\"\")","v":176.25},{"$f":"IF(OR(AL15<=K15,AL15=\"\"),AL15,K15)","v":176.25},{"$f":"IF(L15<>0,0,AB15)","v":100},{"$f":"IF(AM15=\"\",\"\",AM15-AN15)","v":76.25},{"$f":"Y15*100/W15","v":23.248882265275707},{"$f":"AB15/AL15","v":0.56737588652482274},{"$f":"IFERROR(IF(AND(W15>0,X15=\"\",Y15=\"\"),W15,IF(X15>0,W15*(100%-X15),IF(Y15>0,W15-Y15,0))),0)","v":3301.2820512820517}]
[{"$f":"Angebote!A15","v":2},{"$f":"IF(OR(Angebote!$P15=1,Angebote!$P15=2),Angebote!B15,\"\")","v":""},{"$f":"IF(OR(Angebote!$P15=1,Angebote!$P15=2),Angebote!C15,\"\")","v":""},{"$f":"IF(OR(Angebote!$P15=1,Angebote!$P15=2),Angebote!D15,\"\")","v":""},{"$f":"IF(OR(Angebote!$P15=1,Angebote!$P15=2),Angebote!F15,\"\")","v":""},{"$f":"IF(OR(Angebote!$P15=1,Angebote!$P15=2),Angebote!G15,\"\")","v":""},null,null,{"$f":"IF(OR(Angebote!$P15=1,Angebote!$P15=2),Angebote!Q15,\"\")","v":""},null,{"$f":"IF(J16<>0,I16+J16,I16)","v":""},null,null,null,{"$f":"IF(M16=\"\",K16,\"\")","v":""},null,{"$f":"IF(F16=\"\",\"\",VLOOKUP(F16,Einrichtung!$B$13:$E$17,2,0))","v":""},{"$f":"IF(K16=\"\",\"\",Q16*K16)","v":""},null,null,{"$f":"IF(F16=\"\",\"\",VLOOKUP(F16,Einrichtung!$B$13:$E$17,4,0))","v":""},{"$f":"IF(W16=\"\",\"\",(U16*W16)/1000)","v":""},{"$f":"IF(K16=\"\",\"\",(K16-R16-Z16)/(U16/1000))","v":""},null,null,{"$f":"IF(F16=\"\",\"\",VLOOKUP(F16,Einrichtung!$B$13:$E$17,3,0)*K16)","v":""},null,null,{"$f":"IF(AND(U16=\"\",Y16=\"\"),\"\",IF(Y16>W16,U16*W16/1000,Y16*U16/1000))","v":""},{"$f":"IF(R16=\"\",\"\",IF(S16>0,R16*S16,T16))","v":""},{"$f":"IF(AND(X16=\"\",Y16=\"\",),\"\",IF(Y16>0,U16*Y16/1000,(U16*W16)/1000*X16))","v":{"$error":"#VALUE!"}},{"$f":"IF(Z16=0,\"0\",AA16)","v":0},{"$f":"AB16/O16","v":{"$error":"#VALUE!"}},null,{"$f":"IF(M16>0,1,AJ16)","v":0},0,null,{"$f":"IF(AND(L16=\"\",AD16<>\"\"),AD16+AE16+AF16,\"\")","v":""},{"$f":"IF(OR(AL16<=K16,AL16=\"\"),AL16,K16)","v":""},{"$f":"IF(L16<>0,0,AB16)","v":0},{"$f":"IF(AM16=\"\",\"\",AM16-AN16)","v":""},{"$f":"Y16*100/W16","v":{"$error":"#VALUE!"}},{"$f":"AB16/AL16","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(IF(AND(W16>0,X16=\"\",Y16=\"\"),W16,IF(X16>0,W16*(100%-X16),IF(Y16>0,W16-Y16,0))),0)","v":""}]
[{"$f":"Angebote!A16","v":3},{"$f":"IF(OR(Angebote!$P16=1,Angebote!$P16=2),Angebote!B16,\"\")","v":"2016-02-20"},{"$f":"IF(OR(Angebote!$P16=1,Angebote!$P16=2),Angebote!C16,\"\")","v":15479},{"$f":"IF(OR(Angebote!$P16=1,Angebote!$P16=2),Angebote!D16,\"\")","v":"Herr Staber"},{"$f":"IF(OR(Angebote!$P16=1,Angebote!$P16=2),Angebote!F16,\"\")","v":"EFH"},{"$f":"IF(OR(Angebote!$P16=1,Angebote!$P16=2),Angebote!G16,\"\")","v":"Neubau-Privatkd."},"2016-04-10","2016-05-30",{"$f":"IF(OR(Angebote!$P16=1,Angebote!$P16=2),Angebote!Q16,\"\")","v":180},null,180,null,null,null,180,null,{"$f":"IF(F17=\"\",\"\",VLOOKUP(F17,Einrichtung!$B$13:$E$17,2,0))","v":0.38},68.400000000000006,0.5,null,{"$f":"IF(F17=\"\",\"\",VLOOKUP(F17,Einrichtung!$B$13:$E$17,4,0))","v":42.5},57.599999999999987,1355.2941176470586,null,700,{"$f":"IF(F17=\"\",\"\",VLOOKUP(F17,Einrichtung!$B$13:$E$17,3,0)*K17)","v":54},null,50,29.75,34.200000000000003,29.75,0,0.27777777777777779,null,0.3552777777777778,0.3552777777777778,null,63.95,63.95,50,13.950000000000003,51.649305555555564,0.78186082877247842,655.29411764705856]
[{"$f":"Angebote!A17","v":4},{"$f":"IF(OR(Angebote!$P17=1,Angebote!$P17=2),Angebote!B17,\"\")","v":""},{"$f":"IF(OR(Angebote!$P17=1,Angebote!$P17=2),Angebote!C17,\"\")","v":""},{"$f":"IF(OR(Angebote!$P17=1,Angebote!$P17=2),Angebote!D17,\"\")","v":""},{"$f":"IF(OR(Angebote!$P17=1,Angebote!$P17=2),Angebote!F17,\"\")","v":""},{"$f":"IF(OR(Angebote!$P17=1,Angebote!$P17=2),Angebote!G17,\"\")","v":""},null,null,{"$f":"IF(OR(Angebote!$P17=1,Angebote!$P17=2),Angebote!Q17,\"\")","v":""},null,"",null,null,null,"",null,{"$f":"IF(F18=\"\",\"\",VLOOKUP(F18,Einrichtung!$B$13:$E$17,2,0))","v":""},"",null,null,{"$f":"IF(F18=\"\",\"\",VLOOKUP(F18,Einrichtung!$B$13:$E$17,4,0))","v":""},"","",null,null,{"$f":"IF(F18=\"\",\"\",VLOOKUP(F18,Einrichtung!$B$13:$E$17,3,0)*K18)","v":""},null,null,"","",{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},null,null,0,null,"","",0,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},""]
[{"$f":"Angebote!A18","v":5},{"$f":"IF(OR(Angebote!$P18=1,Angebote!$P18=2),Angebote!B18,\"\")","v":""},{"$f":"IF(OR(Angebote!$P18=1,Angebote!$P18=2),Angebote!C18,\"\")","v":""},{"$f":"IF(OR(Angebote!$P18=1,Angebote!$P18=2),Angebote!D18,\"\")","v":""},{"$f":"IF(OR(Angebote!$P18=1,Angebote!$P18=2),Angebote!F18,\"\")","v":""},{"$f":"IF(OR(Angebote!$P18=1,Angebote!$P18=2),Angebote!G18,\"\")","v":""},null,null,{"$f":"IF(OR(Angebote!$P18=1,Angebote!$P18=2),Angebote!Q18,\"\")","v":""},null,{"$f":"IF(J19<>0,I19+J19,I19)","v":""},null,null,null,{"$f":"IF(M19=\"\",K19,\"\")","v":""},null,{"$f":"IF(F19=\"\",\"\",VLOOKUP(F19,Einrichtung!$B$13:$E$17,2,0))","v":""},"",null,null,{"$f":"IF(F19=\"\",\"\",VLOOKUP(F19,Einrichtung!$B$13:$E$17,4,0))","v":""},"","",null,null,{"$f":"IF(F19=\"\",\"\",VLOOKUP(F19,Einrichtung!$B$13:$E$17,3,0)*K19)","v":""},null,null,{"$f":"IF(AND(U19=\"\",Y19=\"\"),\"\",IF(Y19>W19,U19*W19/1000,Y19*U19/1000))","v":""},{"$f":"IF(R19=\"\",\"\",IF(S19>0,R19*S19,T19))","v":""},{"$f":"IF(AND(X19=\"\",Y19=\"\",),\"\",IF(Y19>0,U19*Y19/1000,(U19*W19)/1000*X19))","v":{"$error":"#VALUE!"}},{"$f":"IF(Z19=0,\"0\",AA19)","v":0},{"$error":"#VALUE!"},null,null,0,null,{"$f":"IF(AND(L19=\"\",AD19<>\"\"),AD19+AE19+AF19,\"\")","v":""},"",{"$f":"IF(L19<>0,0,AB19)","v":0},{"$f":"IF(AM19=\"\",\"\",AM19-AN19)","v":""},{"$f":"Y19*100/W19","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},""]
[{"$f":"Angebote!A19","v":6},{"$f":"IF(OR(Angebote!$P19=1,Angebote!$P19=2),Angebote!B19,\"\")","v":""},{"$f":"IF(OR(Angebote!$P19=1,Angebote!$P19=2),Angebote!C19,\"\")","v":""},{"$f":"IF(OR(Angebote!$P19=1,Angebote!$P19=2),Angebote!D19,\"\")","v":""},{"$f":"IF(OR(Angebote!$P19=1,Angebote!$P19=2),Angebote!F19,\"\")","v":""},{"$f":"IF(OR(Angebote!$P19=1,Angebote!$P19=2),Angebote!G19,\"\")","v":""},null,null,{"$f":"IF(OR(Angebote!$P19=1,Angebote!$P19=2),Angebote!Q19,\"\")","v":""},null,"",null,null,null,"",null,{"$f":"IF(F20=\"\",\"\",VLOOKUP(F20,Einrichtung!$B$13:$E$17,2,0))","v":""},"",null,null,{"$f":"IF(F20=\"\",\"\",VLOOKUP(F20,Einrichtung!$B$13:$E$17,4,0))","v":""},"","",null,null,{"$f":"IF(F20=\"\",\"\",VLOOKUP(F20,Einrichtung!$B$13:$E$17,3,0)*K20)","v":""},null,null,"","",{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},null,{"$f":"IF(M20>0,1,AJ20)","v":0},{"$f":"IFERROR(AL20/K20,0)","v":0},null,"","",0,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},""]
[{"$f":"Angebote!A20","v":7},{"$f":"IF(OR(Angebote!$P20=1,Angebote!$P20=2),Angebote!B20,\"\")","v":""},{"$f":"IF(OR(Angebote!$P20=1,Angebote!$P20=2),Angebote!C20,\"\")","v":""},{"$f":"IF(OR(Angebote!$P20=1,Angebote!$P20=2),Angebote!D20,\"\")","v":""},{"$f":"IF(OR(Angebote!$P20=1,Angebote!$P20=2),Angebote!F20,\"\")","v":""},{"$f":"IF(OR(Angebote!$P20=1,Angebote!$P20=2),Angebote!G20,\"\")","v":""},null,null,{"$f":"IF(OR(Angebote!$P20=1,Angebote!$P20=2),Angebote!Q20,\"\")","v":""},null,"",null,null,null,"",null,{"$f":"IF(F21=\"\",\"\",VLOOKUP(F21,Einrichtung!$B$13:$E$17,2,0))","v":""},"",null,null,{"$f":"IF(F21=\"\",\"\",VLOOKUP(F21,Einrichtung!$B$13:$E$17,4,0))","v":""},"","",null,null,{"$f":"IF(F21=\"\",\"\",VLOOKUP(F21,Einrichtung!$B$13:$E$17,3,0)*K21)","v":""},null,null,"","",{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},null,null,0,null,"","",0,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},""]
[{"$f":"Angebote!A21","v":8},{"$f":"IF(OR(Angebote!$P21=1,Angebote!$P21=2),Angebote!B21,\"\")","v":""},{"$f":"IF(OR(Angebote!$P21=1,Angebote!$P21=2),Angebote!C21,\"\")","v":""},{"$f":"IF(OR(Angebote!$P21=1,Angebote!$P21=2),Angebote!D21,\"\")","v":""},{"$f":"IF(OR(Angebote!$P21=1,Angebote!$P21=2),Angebote!F21,\"\")","v":""},{"$f":"IF(OR(Angebote!$P21=1,Angebote!$P21=2),Angebote!G21,\"\")","v":""},null,null,{"$f":"IF(OR(Angebote!$P21=1,Angebote!$P21=2),Angebote!Q21,\"\")","v":""},null,"",null,null,null,"",null,{"$f":"IF(F22=\"\",\"\",VLOOKUP(F22,Einrichtung!$B$13:$E$17,2,0))","v":""},"",null,null,{"$f":"IF(F22=\"\",\"\",VLOOKUP(F22,Einrichtung!$B$13:$E$17,4,0))","v":""},"","",null,null,{"$f":"IF(F22=\"\",\"\",VLOOKUP(F22,Einrichtung!$B$13:$E$17,3,0)*K22)","v":""},null,null,"","",{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},null,{"$f":"IF(M22>0,1,AJ22)","v":0},0,null,"","",0,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},""]
[{"$f":"Angebote!A22","v":9},{"$f":"IF(OR(Angebote!$P22=1,Angebote!$P22=2),Angebote!B22,\"\")","v":""},{"$f":"IF(OR(Angebote!$P22=1,Angebote!$P22=2),Angebote!C22,\"\")","v":""},{"$f":"IF(OR(Angebote!$P22=1,Angebote!$P22=2),Angebote!D22,\"\")","v":""},{"$f":"IF(OR(Angebote!$P22=1,Angebote!$P22=2),Angebote!F22,\"\")","v":""},{"$f":"IF(OR(Angebote!$P22=1,Angebote!$P22=2),Angebote!G22,\"\")","v":""},null,null,{"$f":"IF(OR(Angebote!$P22=1,Angebote!$P22=2),Angebote!Q22,\"\")","v":""},null,"",null,null,null,"",null,{"$f":"IF(F23=\"\",\"\",VLOOKUP(F23,Einrichtung!$B$13:$E$17,2,0))","v":""},"",null,null,{"$f":"IF(F23=\"\",\"\",VLOOKUP(F23,Einrichtung!$B$13:$E$17,4,0))","v":""},"","",null,null,{"$f":"IF(F23=\"\",\"\",VLOOKUP(F23,Einrichtung!$B$13:$E$17,3,0)*K23)","v":""},null,null,"","",{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},null,null,0,null,"","",0,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},""]
[{"$f":"Angebote!A23","v":10},{"$f":"IF(OR(Angebote!$P23=1,Angebote!$P23=2),Angebote!B23,\"\")","v":""},{"$f":"IF(OR(Angebote!$P23=1,Angebote!$P23=2),Angebote!C23,\"\")","v":""},{"$f":"IF(OR(Angebote!$P23=1,Angebote!$P23=2),Angebote!D23,\"\")","v":""},{"$f":"IF(OR(Angebote!$P23=1,Angebote!$P23=2),Angebote!F23,\"\")","v":""},{"$f":"IF(OR(Angebote!$P23=1,Angebote!$P23=2),Angebote!G23,\"\")","v":""},null,null,{"$f":"IF(OR(Angebote!$P23=1,Angebote!$P23=2),Angebote!Q23,\"\")","v":""},null,"",null,null,null,"",null,{"$f":"IF(F24=\"\",\"\",VLOOKUP(F24,Einrichtung!$B$13:$E$17,2,0))","v":""},"",null,null,{"$f":"IF(F24=\"\",\"\",VLOOKUP(F24,Einrichtung!$B$13:$E$17,4,0))","v":""},"","",null,null,{"$f":"IF(F24=\"\",\"\",VLOOKUP(F24,Einrichtung!$B$13:$E$17,3,0)*K24)","v":""},null,null,"","",{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},null,{"$f":"IF(M24>0,1,AJ24)","v":0},0,null,"","",0,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,AL15:AL24)","v":240.2},{"$f":"SUBTOTAL(9,AM15:AM24)","v":240.2},{"$f":"SUBTOTAL(9,AN15:AN24)","v":150},{"$f":"((AN26/AM26))","v":0.62447960033305583},{"$f":"Einrichtung!C33","v":0.7}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stand der teilfertigen Arbeiten zum",null,null,null,null,{"$f":"Einrichtung!C20","v":"2015-12-31"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Einrichtung!D20","v":100}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stand der teilfertigen Arbeiten zum",null,null,null,null,{"$f":"IF(AO8=\"\",\"\",AO8)","v":"2016-04-01"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Einrichtung!W2=2,AM26,AM26-AN26)","v":240.2}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bewertung für die Buchhaltung",null,null,null,null,{"$f":"Einrichtung!C25","v":0.95},null,null,null,null,null,null,null,0,null,null,null,{"$f":"AA32*AM30","v":228.18999999999997}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bestandsveränderungen zum",null,null,null,null,{"$f":"AA30","v":"2016-04-01"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AM28=\"\",\"\",AM32-AM28)","v":128.18999999999997}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summe Aufträge nicht abgerechnet in T€",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,O15:O24)","v":485}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summe offene Aufträge in T€",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,O15:O24)-AL26","v":244.8}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fertigungsstand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AL26/AM36","v":0.49525773195876288}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summe Auslastung in Stunden",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Einrichtung!C29=\"\",\"-\",AM38*Einrichtung!G27*1000/Einrichtung!C29)","v":3700.4651162790697}]

{"sheet":"Einrichtung","index":5,"n_rows":35,"n_cols":23,"rows_kept":35,"cut":false,"hidden":false,"merged":[[10,1,10,4]]}
[]
[null,"Auftragsplanung | Einrichtung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,2]
[]
[null,{"$f":"Start!AA4&\"      \"&\" \"&Intern!A4","v":"Firma:  Mustermann GmbH       Version 1.20"}]
[]
[]
[]
[]
[]
[]
[null,"Eingabe der Planvorgaben"]
[null,"Produktbereich","Materialeinsatz in %","Fremdleistung\nin %","Stundensatz\nVorgabezeit"]
[null,"Neubau-Privatkd.",0.38,0.3,42.5]
[null,"Gewerbebau",0.35,0.1,39]
[null,"Renovierung",0.3,0.1,45]
[null,"Umbau",0.3,0,45]
[null,"Bauträger",0.35,0.15,39]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ja / umsatzwirksam"]
[null,null,"Vorjahr","Wert in T€",null,null,null,null,null,null,null,null,"Ja / nicht umsatzwirksam"]
[null,"Stand der teilfertigen Arbeiten zum","2015-12-31",100,null,null,null,null,null,null,null,null,"Ja / nicht umsatzwirksam"]
[]
[null,"Teilzahlung berücksichtigen"]
[]
[]
[null,"Bewertung für die Buchaltung / BWA",0.95]
[]
[null,"Basismaterialeinsatz für Auslastung",0.35,null,null,null,{"$f":"100%-C27","v":0.65}]
[]
[null,"Basisstundensatz für Auslastung",43]
[]
[null,"Mindestauslastung in Stunden",1500]
[]
[null,"Anteil Teilrechnung zu HF- Arbeiten",0.7]
[]
[null,"Mindestbestand Angebote in T€",300]

{"sheet":"Anleitung","index":6,"n_rows":4,"n_cols":22,"rows_kept":4,"cut":false,"hidden":false,"merged":[[10,1,10,3]]}
[]
[null,"Auftragsplanung | Anleitung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[null,{"$f":"\"  \"&Start!AA4&\"      \"&\" \"&Intern!A4","v":"  Firma:  Mustermann GmbH       Version 1.20"}]

{"sheet":"Intern","index":7,"n_rows":37,"n_cols":2,"rows_kept":37,"cut":false,"hidden":true,"merged":[[3,2,3,4]]}
[]
["UnternehmerKompass© 2012 Auftragsplanung - Intern"]
[]
["Version 1.20","© bauerundpartner"]
[]
[]
[]
[]
[]
[]
[]
["Changelog:"]
[]
["16.09.2010: - Veränderung der Formel im Auftragsblatt (Berechnung der gel. IST Arbeitszeit korrigiert. Nicht über 100%)"]
["15.10.2010: - Veränderung / Hinzufügen des Indexeintrags \"Erfasst durch\" & Verlinkung"]
["14.01.2011: Umstrukturierung Auftragsübersicht IST PLAN, Auftragsquote JAHR, Kopfzeilenveränderung Monat, Erfassungsdatum, Zellensperrung bei Fehleingaben sowie Fehlermeldungen"]
["09.02.2011: Version 1.04 / 500 Zeilen, Zellensperrungen, \"erhaltene AZ\" -> \"verbuchte Teilrechnung\""]
["30.05.2012: Version 1.05 / erhaltene Teilzahlung als Umsatz gebucht (Switch) hinzugefügt "]
["03.07.2012: Version 1.06 / Einblendung Blattregister, Einrichtung kompett gesperrt, Rechnungsdatum rot bei Fertigstellung 100%, Bewertung Teilf. rot bei Differenz zu Auftragswert"]
[]
["10.07.2012: - separate Zeile um T€ sichtbar zu machen (Filter), Auftragswert rot & Kommentar, doppelstriche Abschlussrechnung, seit 30 Tagen… rot, Dropdown Angebote"]
["13.07.2012: Version 1.07 / offen rot, Sortierfunktion Angebote"]
[]
["30.07.2012: Version 1.08 / Anleitung \"Auslastung\" ergänzt, Formel \"Summe Auslastung in Std.\" korrigiert, Einrichtung ergänzt"]
["02.10.2012: Version 1.09 Switch Aufträge Abschlussrechnung \"ja\" = schwarz"]
[]
[]
[]
["21.02.2012: Versionsaktualisierung neues CI - switch bei kapazität > 100% -> rot"]
[]
[]
["28.03.2013: Version: 1.140328 Versionsanzeige im Hauptmenü, neues CI + Spaltenvergrößerungen, Eingabebutton & Auswertungsbutton in Sheet Angebote, Rechnungsdatum wird rot bei >95% Fertigstellung, Beginn & Fertigstellung rot"]
[]
["07.04.2013: Version: 1.1404 Veränderung bzgl. Sortierungsfunktion Aufträge Datumsspalte"]
[]
[]
["11.04.2016: Version: 1.20: - Viele Verbesserungen & Bugfixes, darunter Programmierung neuer Funktionen wie z.B. Chefinfoübersicht. Diese ist noch nicht einglendet, da die Handlungsanweisungen fehlen"]